How to delete all leave balance record of a particular leave type eg. Sick Leave | Aruti

To delete any existing leave balance records including leave b/f, accrued, issued , adjustment & encashment of a particular leave type, please follow below process 

1. Take backup of the database
2. Login to the sql studio 
3. Select the database along with the year required 
4. Right click and choose run new query
5. Write the query as below and execute: 

select * from lvleavetype_master (this will allow you view the various leave types and their leavetypeunkid)

delete lvleavebalance_tran where leavetypeunkid=4 (this will allow you to delete the leave records for that particular leave type)

Find below screenshot for process.